PROMPT *-*-*-*-*-* shk2_batch_jobs_srefmst table createion STARTS... *-*-*-*-*-*

DROP SEQUENCE batch_job_seq;

CREATE SEQUENCE batch_job_seq
START WITH 1000
MINVALUE 1000
MAXVALUE 999999999
INCREMENT BY 1;

DROP TABLE shk2_batch_jobs_srefmst;

CREATE TABLE shk2_batch_jobs_srefmst
( batch_job_id     NUMBER  PRIMARY KEY
, batch_job_nm     VARCHAR2(30)
, brn_cd           VARCHAR2(10)
, prod_cd          VARCHAR2(10));


BEGIN
INSERT INTO shk2_batch_jobs_srefmst(batch_job_id, batch_job_nm,brn_cd, prod_cd) 
                VALUES(batch_job_seq.NEXTVAL,'DATA_MGR_SP', 'ALL', 'ALL');
							 
INSERT INTO shk2_batch_jobs_srefmst(batch_job_id, batch_job_nm,brn_cd, prod_cd) 
               VALUES(batch_job_seq.NEXTVAL,'REPORT_GEN_SP','ALL','ALL');							 
COMMIT;
END;
/

PROMPT *-*-*-*-*-* shk2_batch_jobs_srefmst table createion ENDS... *-*-*-*-*-*

PROMPT *-*-*-*-*-* shk2_batch_instance_txnmst table createion STARTS... *-*-*-*-*-*

DROP SEQUENCE instance_seq;

CREATE SEQUENCE instance_seq
START WITH 5550
MINVALUE 5550
MAXVALUE 999999999
INCREMENT BY 1;
	
DROP TABLE shk2_batch_instance_txnmst;

CREATE TABLE shk2_batch_instance_txnmst
( batch_job_instance_id   NUMBER
, batch_job_id            NUMBER
, start_dttm              TIMESTAMP
, end_dttm                TIMESTAMP
, job_run_status_flg      CHAR
, job_run_status_dttm     TIMESTAMP);

PROMPT *-*-*-*-*-* shk2_batch_instance_txnmst table createion ENDS... *-*-*-*-*-*

PROMPT *-*-*-*-*-* shk2_batch_instance_err table createion STARTS... *-*-*-*-*-*

DROP SEQUENCE err_seq;
 
CREATE SEQUENCE err_seq;

DROP TABLE shk2_batch_instance_err;

CREATE TABLE shk2_batch_instance_err
( error_id                NUMBER
, batch_job_instance_id   NUMBER
, error_module_nm         VARCHAR2(30)      
, error_object_nm         VARCHAR2(30)
, error_details_txt       VARCHAR2(50)
);

PROMPT *-*-*-*-*-* shk2_batch_instance_err table createion ENDS... *-*-*-*-*-*